{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculs","Références"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calculs","index":0,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Remise à jour annuelle de la composition du prix de revient."]
["Prix de reveient = coût de production - aides affectées"]
[null,"Références"]
["Données du groupe","AB Zone herbagère",null,"Modifs"]
["Productivité numérique",1.45,null,1.45]
["Taux renouvellement %",25,null,25]
["Nombre d'agneaux vendus par brebis",{"$f":"B5-(B5*B6/100)","v":1.0874999999999999},null,{"$f":"D5-(D5*D6/100)","v":1.0874999999999999}]
["Kgs carcasse vendu/agneau",{"$f":"(B9-B10-B11)/B7","v":18.501149425287355},null,18.5]
["Equivalent Kgs carcasse/brebis",22.8,null,{"$f":"D8*D7+(B10+B11)","v":22.798749999999998}]
["Part réformes en kgs carcasse/brebis",1.58]
["Part des achats en moins en kgs carcasse/brebis",1.1000000000000001]
["Kgs de concentrés consommés/brebis",102,null,102]
["€/kg du cocnentré acheté et prélevé (prix de cession)",0.42399999999999999,null,0.42399999999999999]
["Coût du concentré / brebis",{"$f":"B12*B13","v":43.247999999999998},null,{"$f":"D12*D13","v":43.247999999999998}]
[]
[null,"Références","Références","Résultats"]
["Coût de prod Ovins avec céré prix cession","€/kg carcasse","€/brebis","€/kg carcasse"]
["Alimentation (yc alic prélevés et fourrages)",1.94,{"$f":"B18*$B$9","v":44.231999999999999},{"$f":"((C18-B14)+D14)/$D$9","v":1.9401063654805637}]
["Frais d'élevage (hors achats d'Ax yc véto+CMV)",1.42,{"$f":"B19*$B$9","v":32.375999999999998},{"$f":"C19/$D$9","v":1.4200778551455673}]
["Part génétique des achats d'Ax",0.06,1.3679999999999999,6.0003289654038047E-2]
["Frais SFP hors entreprise",0.44,10.032,0.44002412412961239]
["Total Charges proportionnelles",{"$f":"SUM(B18:B21)","v":3.86},null,{"$f":"SUM(D18:D21)","v":3.8602116344097817}]
["CP non affectables",7.0000000000000007E-2,{"$f":"B23*$B$9","v":1.5960000000000003},7.0003837929711071E-2]
["Mécanisation",1.31,29.868000000000002,1.3100718241131644]
["Bâtiments + clôtures",0.41,9.347999999999999,0.41002247930259333]
["Frais de gestion (ou ch.div.)",0.81,18.468000000000004,0.81004441032951391]
["Ch. Foncières",0.85,19.38,0.85004660343220573]
["Frais financiers",7.0000000000000007E-2,1.5960000000000003,7.0003837929711071E-2]
["Trav.(sala+Msa+Agri)",0.8,18.240000000000002,0.80004386205384082]
["Rémun. nette de MO fam Ov à 1.5 SMIC",2.44,55.631999999999998,2.4401337792642139]
["Rémun. du capital propre",0.13,2.9640000000000004,0.13000712758374913]
["Tot ch.fixes hors rémun trav+cap",{"$f":"B24+B25+B26+B27+B28+B29+B23","v":4.32},{"$f":"C24+C25+C26+C27+C28+C29+C23","v":98.496000000000009},{"$f":"D24+D25+D26+D27+D28+D29+D23","v":4.3202368550907408}]
["Rémunération du travail et du capital",{"$f":"B31+B30","v":2.57},{"$f":"C31+C30","v":58.595999999999997},{"$f":"D31+D30","v":2.5701409068479633}]
["TOTAL coût de production",{"$f":"B33+B32+B22","v":10.75},{"$f":"C33+C32+C22","v":157.09200000000001},{"$f":"D33+D32+D22","v":10.750589396348486}]
["Aides atelier Ovin",1.17,{"$f":"B35*$B$9","v":26.675999999999998},{"$f":"C35/D9","v":1.1700641482537419}]
["Aides non couplées",3.13,71.364000000000004,{"$f":"C36/D9","v":3.1301716102856521}]
["Variation d'aide",null,null,{"$f":"D43/D9","v":0}]
["Prix de revient pour rémunérer à 1.5 SMIC net",{"$f":"B34-B35-B36","v":6.45},{"$f":"C34-C35-C36","v":59.052000000000021},{"$f":"D34-D35-D36-D37","v":6.4503536378090924}]
["Prix de vente réel",null,null,6.45]
["Rémunération en nb SMIC",null,null,{"$f":"(D39-(D38-D30))*1.5/D30","v":1.4997826116264006},"Nb SMIC = ((Prix de vente)-( Prix de revient - Rémun MO (Prix à payer pour couvrir les charges)))*1.5/Rémun MO."]
["Aides atelier Ovin / brebis",null,null,{"$f":"D35*D9","v":26.675999999999998},null,"soit : Nouvelle rémun de la MO/Rémun MO pour 1.5SMIC * 1.5 SMIC"]
["Aides non couplées / brebis",null,null,{"$f":"D36*D9","v":71.364000000000004}]
["Aides en + ou en - /brebs",null,null,0]
["Graphique coût de production :"]
[null,{"$f":"B4","v":"AB Zone herbagère"},null,{"$f":"D4","v":"Modifs"}]
["Charges proportionnelles",{"$f":"B22","v":3.86},null,{"$f":"D22","v":3.8602116344097817}]
["Charges fixes sans travail et capital",{"$f":"B32","v":4.32},null,{"$f":"D32","v":4.3202368550907408}]
["Rémunération du travail et du capital",{"$f":"B33","v":2.57},null,{"$f":"D33","v":2.5701409068479633}]
["Prix de revient",{"$f":"B38","v":6.45},null,{"$f":"D38","v":6.4503536378090924}]
[]
[]
[]
[null,{"$f":"B4","v":"AB Zone herbagère"}]
["Nb brebis/UTH ovin",366]
["Nb brebis /ha de SFP",5.4]

{"sheet":"Références","index":1,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Références","Références"]
["Données du groupe","AB Zone rustique","AB Zone herbagère"]
["Productivité numérique",1.28,1.45]
["Taux renouvellement %",18,25]
[]
[]
["Equivalent Kgs carcasse/brebis",17.3,22.8]
["Part réformes en kgs carcasse/brebis",0,1.58]
["Part des achats en moins en kgs carcasse/brebis",0,1.1000000000000001]
["Kgs de concentrés consommés/brebis",125,102]
["€/kg du cocnentré acheté et prélevé (prix de cession)",0.39100000000000001,0.42399999999999999]
[]
[]
[null,"Références","Références"]
["Coût de prod Ovins avec céré prix cession","€/kg carcasse","€/kg carcasse"]
["Alimentation (yc alic prélevés et fourrages)",3.03,1.94]
["Frais d'élevage (hors achats d'Ax yc véto+CMV)",1.1100000000000001,1.42]
["Part génétique des achats d'Ax",0.21,0.06]
["Frais SFP hors entreprise",0.43,0.44]
[]
["CP non affectables",0.13,7.0000000000000007E-2]
["Mécanisation",2.46,1.31]
["Bâtiments + clôtures",0.8,0.41]
["Frais de gestion (ou ch.div.)",1.48,0.81]
["Ch. Foncières",1.34,0.85]
["Frais financiers",0.16,7.0000000000000007E-2]
["Trav.(sala+Msa+Agri)",0.76,0.8]
["Rémun. nette de MO fam Ov à 1.5 SMIC",4.42,2.44]
["Rémun. du capital propre",0.11,0.13]
[]
[]
[]
["Aides atelier Ovin",1.51,1.17]
["Aides non couplées",6.19,3.13]
[]
["Nb brebis/UTH ovin",267,366]
["Nb brebis /ha de SFP",4.5,5.4]